//
//  SQLHandler.h
//  echo
//
//  Created by dllo on 16/3/2.
//  Copyright © 2016年 Danny. All rights reserved.
//

@class ModelOfCellForMyExploreTableViewSectionThreeAndFour;

#import <Foundation/Foundation.h>

@interface SQLHandler : NSObject
+ (instancetype)shareSQLTable;

+ (void)openSQL;
+ (void)createSQLTable;
- (void)insertData:(ModelOfCellForMyExploreTableViewSectionThreeAndFour *)model;
+ (void)updateData:(ModelOfCellForMyExploreTableViewSectionThreeAndFour *)model forNumber:(NSInteger)number;
+ (void)deleteData:(NSString *)name;
+ (NSArray *)searchData;
+ (void)deleteTable;
+ (void)closeSQL;

+ (void)openSQLForClassifyVC;
+ (void)createSQLTableForClassifyVC;
- (void)insertDataForClassifyVC:(NSMutableDictionary *)model;
+ (void)updateDataForClassifyVC:(NSMutableDictionary *)model forNumber:(NSInteger)number;
+ (void)deleteDataForClassifyVC:(NSString *)name;
+ (NSArray *)searchDataForClassifyVC;
+ (void)deleteTableForClassifyVC;
@end
